Jason Tarpinian
Jason Tarpinian
Reactions
-
Re: Is there a way to show a particular image in a dashboard depending on which option is selected?
You can't return physical images through a formula. The best workaround I could think of would be to create a sheet with your logic built into a checkbox (IF open, true, else false), with a correspon…1 · -
Re: Count Distinct is Clearly Incorrect.
Check to make sure that you don't have any #ERROR in the range you're calculating. I'm able to replicate your issue with it returning 1 with an #ERROR int eh range, but once I remove it, it counts up…1 · -
Re: HAS() inside COLLECT()
Because I'm in a hungry mood, this might do what you need: =MAX(COLLECT([Row ID]:[Row ID], Fruit:Fruit, HAS(@cell, "Kiwi"))) Where fruit would be your multi-select column, then just replace…1 · -
Re: Grid/Report Linked Cell Issue
The only way you'd be able to change a field in a report is if it's not a formula/link. If you've removed the formula/link from the source sheet, maybe you had your report open before you made the ch…1 · -
Re: Return just one row in my report
I don't know Bridge, so can't answer to that, but I've seen a solution in which you create a form an a separate sheet where you could select the "TitleID" you'd like to see filtered to. Hav…1 ·
